<!--
File Name 	: 	attendLateExcel.jsp
기능			:	액셀 다운로드
-->
<%@ page 	language="java" 	contentType="application/vnd.ms-excel; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page 	import="java.util.Date"%>
<%@ taglib 	prefix="s" 			uri="/struts-tags"%>
<%
	response.setHeader("Content-Disposition", "attachment; filename=PHILERGYSYSTEM_"+ new SimpleDateFormat("yyyyMMddHHmm").format(new Date()) +"_excel.xls"); 
    response.setHeader("Content-Description", "JSP Generated Data"); 

	//[출처] 간단하게 JSP로 Excel파일 생성하기(excel,엑셀) - 자바누리|작성자 비온디
 %>

<%@page import="java.text.SimpleDateFormat"%>
<html>
<!-- ============================== BODY START ==============================-->
<head>
	<meta http-equiv="Content-Type" 	content="text/html; charset=UTF-8" />
	<meta http-equiv="pragma" 			content="no-cache" />
	<meta http-equiv="cache-control" 	content="no-cache" />
	<meta http-equiv="expires" 			content="0" />
	<title>근태관리확인-관리자</title>
	
	<!-- ============================== J A V A S C R I P T		S T  A R T ============================== -->
	<script type="text/javascript">
		<!--
		//-->
	</script>
</head>
<!-- ============================== BODY START ============================== -->
<body>

	<table border="1">
		 <tr>
			<th class="th_header"rowspan="2">사업부</th>
			<th class="th_header"rowspan="2">팀</th>
			<th class="th_header"rowspan="2">성명</th>
			<th class="th_header"colspan="2">근태 반영</th>
			<th class="th_header"rowspan="2">기준<br/>일자</th>
			<th class="th_header"rowspan="2">요<br/>일</th>
			<th class="th_header"rowspan="2">출근<br/>날짜</th>
			<th class="th_header"rowspan="2">출근 <br/>시간</th>
			<th class="th_header"rowspan="2">출근 <br/>IP</th>
			<th class="th_header"rowspan="2">출근<br/>상세</th>
			<th class="th_header"rowspan="2">입력자<br/> 비고</th>
			<th class="th_header"rowspan="2">확인자<br/>비고</th>
			<th class="th_header"rowspan="2">확인자</th>
		</tr>
		<tr>
			    <th class="th_header">시작일</th>
			    <th class="th_header">종료일</th>
       </tr>
		<s:iterator value="list">
          <tr>
              <td><s:property value="group_nm" /></td>
              <td><s:property value="team_nm" /></td>
              <td><s:property value="emp_nm" /></td>
              <td><s:property value="vaca_s_date" /></td>
              <td><s:property value="vaca_e_date" /></td>
              <td><s:property value="yyyymmdd" /></td>
              <td><s:property value="dayname" /></td>
              <td><s:property value="in_out_dt" /></td>
              <td><s:property value="in_out_time" /></td>
              <td><s:property value="reg_ip" /></td>
              <td><s:property value="in_out_detail_nm" /></td>
              <td><s:property value="etc_emp_memo" /></td>
              <td><s:property value="etc_mgr" /></td>
              <td><s:property value="approv_emp_nm"/></td>
          </tr>
       </s:iterator>
	</table>
</body>
<!-- ============================== BODY END ============================== -->

</html>